Home > mailing lists

ORDER BY question - Mailing list pgsql-sql

From	Charles Hauser
Subject	ORDER BY question
Date	November 20, 2001 02:40:15
Msg-id	a05010403b819f5e7857d@[152.3.11.193] Whole thread Raw
Responses	Re: ORDER BY question (Masaru Sugawara <rk73@echna.ne.jp>) Re: ORDER BY question ("Andrew G. Hammond" <drew@xyzzy.dhs.org>)
List	pgsql-sql

Tree view

Hope this is the correct forum - if not sorry.

I have a query which returns a value of the form: '20010822.1338.1'.

I would like to order the results, sorting :
    1st: 20010822    2nd: 1338    3rd: 1


I can do this in perl, but have not found a way to do this using ORDER BY.

I am VERY new to DB's; biologist trying to do informatics.

Thanks.
-- 
Chuck

pgsql-sql by date:

From: Jason Earl
Date: 20 November 2001, 02:38:49
Subject: Re: Optimization with dates

From: dinocherian@yahoo.com (dino ck)
Date: 20 November 2001, 02:40:23
Subject: How to return more than one row of data from a function in PL/pgSQL

ORDER BY question - Mailing list pgsql-sql

Previous

Next